
Accueil > Answers > What formula can I use in Excel 2007 to create one list twa1310542573
What formula can I use in Excel 2007 to create one list from another?
Please see the image for a visual representation of this. The left-hand list contains the information I want, at regular intervals of 3 rows. I want to copy only this information into a list on the right, which would no longer be separated by rows.
I've already tried 2 things: in C1, C2 and C3 putting =A1, =A4 and =A7, but when I highlight and pull down to copy the formula, the formula doesn't continue upwards (i.e. A10, A13 etc.) so the results are inaccurate.
I've also tried =A3, =A(3+5), but it doesn't like the brackets at all.
Although the question is quite complex, what I am asking is actually very simple.
Does anyone have a solution?
- Secteur d’activité/Domaine : Logiciels
- Catégorie : Les logiciels de productivité
- Created: 02:36, 13 July 2011
Créateur
Blossaires en vedette
stanley soerianto
0
Termes
107
Blossaires
6
Abonnés
Indonesia Football Team
Catégorie : Sports 3
10 Termes


rufaro9102
0
Termes
41
Blossaires
4
Abonnés
Best Mobile Phones 2014
Catégorie : Technologie 2
2 Termes


karel24
0
Termes
23
Blossaires
1
Abonnés
The Asian Banker Awards Program
Catégorie : Business 1
5 Termes

weavingthoughts
0
Termes
4
Blossaires
0
Abonnés
Facts about one horned Rhino
Catégorie : Animaux 1
1 Termes
